package com.dingding.service.core.common.sql;

/**
 * 
 * @ClassName: DriverChannelSQL 
 * @Description: 
 * @author hufan
 * @date 2016年12月21日 下午2:31:58 
 *
 */
public class ChannelSQL {

	/**
	 * 根据channelid查询有效渠道
	 * @author hufan
	 */
	public static final String QUERY_REGISTER_CHANNEL_BY_CHANNELID = "SELECT `channelId`,`channelNameEn`,`channelName`,`channelStatus`,`organizationId` FROM `dd_register_channel` WHERE `channelStatus` = 1 AND `channelId` = ?";

	/**
	 * 根据用户id查询该用户的来源渠道
	 * @author hufan
	 */
	public static final String QUERY_CHANNEL_REF_USER_BY_USERID = "SELECT `channelRefUserId`,`channelId`,`userId`,`userTelPhone`,`registerType`,`createTime` FROM `dd_channel_ref_user` WHERE `userId` = ?";
}
